package com.ztesoft.web.common.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class DmHostConnInfoArg {
    private String pk_name = "HOST_ID";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<DmHostConnInfoCriteria> oredCriteria;

    public DmHostConnInfoArg() {
        oredCriteria = new ArrayList<DmHostConnInfoCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<DmHostConnInfoCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(DmHostConnInfoCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public DmHostConnInfoCriteria or() {
    	DmHostConnInfoCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DmHostConnInfoCriteria createCriteria() {
    	DmHostConnInfoCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected DmHostConnInfoCriteria createCriteriaInternal() {
    	DmHostConnInfoCriteria criteria = new DmHostConnInfoCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<DmHostConnInfoCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<DmHostConnInfoCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<DmHostConnInfoCriterion> getAllCriteria() {
            return criteria;
        }

        public List<DmHostConnInfoCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new DmHostConnInfoCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmHostConnInfoCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmHostConnInfoCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new DmHostConnInfoCriterion(condition, value1, value2));
        }

        public DmHostConnInfoCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (DmHostConnInfoCriteria) this;
        }
        public DmHostConnInfoCriteria andHostIdIsNull() {
            addCriterion("HOST_ID is null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdIsNotNull() {
            addCriterion("HOST_ID is not null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdEqualTo(Integer value) {
            addCriterion("HOST_ID =", value, "HOST_ID");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdNotEqualTo(Integer value) {
            addCriterion("HOST_ID <>", value, "HOST_ID");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdGreaterThan(Integer value) {
            addCriterion("HOST_ID >", value, "HOST_ID");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("HOST_ID >=", value, "HOST_ID");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdLessThan(Integer value) {
            addCriterion("HOST_ID <", value, "HOST_ID");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdLessThanOrEqualTo(Integer value) {
            addCriterion("HOST_ID <=", value, "HOST_ID");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdLike(Integer value) {
            addCriterion("HOST_ID like ", value, "HOST_ID", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdNotLike(Integer value) {
            addCriterion("HOST_ID  not like ", value, "HOST_ID", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdLeftLike(Integer value) {
            addCriterion("HOST_ID like ", value, "HOST_ID", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdNotLeftLike(Integer value) {
            addCriterion("HOST_ID  not like ", value, "HOST_ID", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdRightLike(Integer value) {
            addCriterion("HOST_ID like ", value, "HOST_ID", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdNotRightLike(Integer value) {
            addCriterion("HOST_ID  not like ", value, "HOST_ID", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdIn(List<Integer> values) {
            addCriterion("HOST_ID  in ", values, "HOST_ID");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdNotIn(List<Integer> values) {
            addCriterion("HOST_ID not in ", values, "HOST_ID");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdBetween(Integer value1, Integer value2) {
            addCriterion("HOST_ID between ", value1, value2, "HOST_ID");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostIdNotBetween(Integer value1, Integer value2) {
            addCriterion("HOST_ID not between ", value1, value2, "HOST_ID");
            return (DmHostConnInfoCriteria) this;
        }
        public DmHostConnInfoCriteria andHostNameIsNull() {
            addCriterion("HOST_NAME is null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameIsNotNull() {
            addCriterion("HOST_NAME is not null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameEqualTo(String value) {
            addCriterion("HOST_NAME =", value, "HOST_NAME");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameNotEqualTo(String value) {
            addCriterion("HOST_NAME <>", value, "HOST_NAME");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameGreaterThan(String value) {
            addCriterion("HOST_NAME >", value, "HOST_NAME");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameGreaterThanOrEqualTo(String value) {
            addCriterion("HOST_NAME >=", value, "HOST_NAME");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameLessThan(String value) {
            addCriterion("HOST_NAME <", value, "HOST_NAME");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameLessThanOrEqualTo(String value) {
            addCriterion("HOST_NAME <=", value, "HOST_NAME");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameLike(String value) {
            addCriterion("HOST_NAME like ", value, "HOST_NAME", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameNotLike(String value) {
            addCriterion("HOST_NAME  not like ", value, "HOST_NAME", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameLeftLike(String value) {
            addCriterion("HOST_NAME like ", value, "HOST_NAME", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameNotLeftLike(String value) {
            addCriterion("HOST_NAME  not like ", value, "HOST_NAME", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameRightLike(String value) {
            addCriterion("HOST_NAME like ", value, "HOST_NAME", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameNotRightLike(String value) {
            addCriterion("HOST_NAME  not like ", value, "HOST_NAME", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameIn(List<String> values) {
            addCriterion("HOST_NAME  in ", values, "HOST_NAME");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameNotIn(List<String> values) {
            addCriterion("HOST_NAME not in ", values, "HOST_NAME");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameBetween(String value1, String value2) {
            addCriterion("HOST_NAME between ", value1, value2, "HOST_NAME");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andHostNameNotBetween(String value1, String value2) {
            addCriterion("HOST_NAME not between ", value1, value2, "HOST_NAME");
            return (DmHostConnInfoCriteria) this;
        }
        public DmHostConnInfoCriteria andIpIsNull() {
            addCriterion("IP is null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpIsNotNull() {
            addCriterion("IP is not null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpEqualTo(String value) {
            addCriterion("IP =", value, "IP");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpNotEqualTo(String value) {
            addCriterion("IP <>", value, "IP");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpGreaterThan(String value) {
            addCriterion("IP >", value, "IP");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpGreaterThanOrEqualTo(String value) {
            addCriterion("IP >=", value, "IP");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpLessThan(String value) {
            addCriterion("IP <", value, "IP");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpLessThanOrEqualTo(String value) {
            addCriterion("IP <=", value, "IP");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpLike(String value) {
            addCriterion("IP like ", value, "IP", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpNotLike(String value) {
            addCriterion("IP  not like ", value, "IP", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpLeftLike(String value) {
            addCriterion("IP like ", value, "IP", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpNotLeftLike(String value) {
            addCriterion("IP  not like ", value, "IP", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpRightLike(String value) {
            addCriterion("IP like ", value, "IP", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpNotRightLike(String value) {
            addCriterion("IP  not like ", value, "IP", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpIn(List<String> values) {
            addCriterion("IP  in ", values, "IP");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpNotIn(List<String> values) {
            addCriterion("IP not in ", values, "IP");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpBetween(String value1, String value2) {
            addCriterion("IP between ", value1, value2, "IP");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andIpNotBetween(String value1, String value2) {
            addCriterion("IP not between ", value1, value2, "IP");
            return (DmHostConnInfoCriteria) this;
        }
        public DmHostConnInfoCriteria andBusiSysIsNull() {
            addCriterion("BUSI_SYS is null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysIsNotNull() {
            addCriterion("BUSI_SYS is not null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysEqualTo(String value) {
            addCriterion("BUSI_SYS =", value, "BUSI_SYS");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysNotEqualTo(String value) {
            addCriterion("BUSI_SYS <>", value, "BUSI_SYS");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysGreaterThan(String value) {
            addCriterion("BUSI_SYS >", value, "BUSI_SYS");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysGreaterThanOrEqualTo(String value) {
            addCriterion("BUSI_SYS >=", value, "BUSI_SYS");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysLessThan(String value) {
            addCriterion("BUSI_SYS <", value, "BUSI_SYS");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysLessThanOrEqualTo(String value) {
            addCriterion("BUSI_SYS <=", value, "BUSI_SYS");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysLike(String value) {
            addCriterion("BUSI_SYS like ", value, "BUSI_SYS", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysNotLike(String value) {
            addCriterion("BUSI_SYS  not like ", value, "BUSI_SYS", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysLeftLike(String value) {
            addCriterion("BUSI_SYS like ", value, "BUSI_SYS", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysNotLeftLike(String value) {
            addCriterion("BUSI_SYS  not like ", value, "BUSI_SYS", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysRightLike(String value) {
            addCriterion("BUSI_SYS like ", value, "BUSI_SYS", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysNotRightLike(String value) {
            addCriterion("BUSI_SYS  not like ", value, "BUSI_SYS", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysIn(List<String> values) {
            addCriterion("BUSI_SYS  in ", values, "BUSI_SYS");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysNotIn(List<String> values) {
            addCriterion("BUSI_SYS not in ", values, "BUSI_SYS");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysBetween(String value1, String value2) {
            addCriterion("BUSI_SYS between ", value1, value2, "BUSI_SYS");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andBusiSysNotBetween(String value1, String value2) {
            addCriterion("BUSI_SYS not between ", value1, value2, "BUSI_SYS");
            return (DmHostConnInfoCriteria) this;
        }
        public DmHostConnInfoCriteria andOsTypeIsNull() {
            addCriterion("OS_TYPE is null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeIsNotNull() {
            addCriterion("OS_TYPE is not null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeEqualTo(String value) {
            addCriterion("OS_TYPE =", value, "OS_TYPE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeNotEqualTo(String value) {
            addCriterion("OS_TYPE <>", value, "OS_TYPE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeGreaterThan(String value) {
            addCriterion("OS_TYPE >", value, "OS_TYPE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeGreaterThanOrEqualTo(String value) {
            addCriterion("OS_TYPE >=", value, "OS_TYPE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeLessThan(String value) {
            addCriterion("OS_TYPE <", value, "OS_TYPE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeLessThanOrEqualTo(String value) {
            addCriterion("OS_TYPE <=", value, "OS_TYPE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeLike(String value) {
            addCriterion("OS_TYPE like ", value, "OS_TYPE", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeNotLike(String value) {
            addCriterion("OS_TYPE  not like ", value, "OS_TYPE", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeLeftLike(String value) {
            addCriterion("OS_TYPE like ", value, "OS_TYPE", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeNotLeftLike(String value) {
            addCriterion("OS_TYPE  not like ", value, "OS_TYPE", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeRightLike(String value) {
            addCriterion("OS_TYPE like ", value, "OS_TYPE", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeNotRightLike(String value) {
            addCriterion("OS_TYPE  not like ", value, "OS_TYPE", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeIn(List<String> values) {
            addCriterion("OS_TYPE  in ", values, "OS_TYPE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeNotIn(List<String> values) {
            addCriterion("OS_TYPE not in ", values, "OS_TYPE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeBetween(String value1, String value2) {
            addCriterion("OS_TYPE between ", value1, value2, "OS_TYPE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andOsTypeNotBetween(String value1, String value2) {
            addCriterion("OS_TYPE not between ", value1, value2, "OS_TYPE");
            return (DmHostConnInfoCriteria) this;
        }
        public DmHostConnInfoCriteria andStateIsNull() {
            addCriterion("STATE is null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "STATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "STATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "STATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "STATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "STATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "STATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateLike(String value) {
            addCriterion("STATE like ", value, "STATE", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateNotLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateLeftLike(String value) {
            addCriterion("STATE like ", value, "STATE", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateNotLeftLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateRightLike(String value) {
            addCriterion("STATE like ", value, "STATE", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateNotRightLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateIn(List<String> values) {
            addCriterion("STATE  in ", values, "STATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in ", values, "STATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between ", value1, value2, "STATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between ", value1, value2, "STATE");
            return (DmHostConnInfoCriteria) this;
        }
        public DmHostConnInfoCriteria andStateDateIsNull() {
            addCriterion("STATE_DATE is null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateIsNotNull() {
            addCriterion("STATE_DATE is not null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateEqualTo(Date value) {
            addCriterion("STATE_DATE =", value, "STATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateNotEqualTo(Date value) {
            addCriterion("STATE_DATE <>", value, "STATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateGreaterThan(Date value) {
            addCriterion("STATE_DATE >", value, "STATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("STATE_DATE >=", value, "STATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateLessThan(Date value) {
            addCriterion("STATE_DATE <", value, "STATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateLessThanOrEqualTo(Date value) {
            addCriterion("STATE_DATE <=", value, "STATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateLike(Date value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateNotLike(Date value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateLeftLike(Date value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateNotLeftLike(Date value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateRightLike(Date value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateNotRightLike(Date value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateIn(List<Date> values) {
            addCriterion("STATE_DATE  in ", values, "STATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateNotIn(List<Date> values) {
            addCriterion("STATE_DATE not in ", values, "STATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateBetween(Date value1, Date value2) {
            addCriterion("STATE_DATE between ", value1, value2, "STATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andStateDateNotBetween(Date value1, Date value2) {
            addCriterion("STATE_DATE not between ", value1, value2, "STATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }
        public DmHostConnInfoCriteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateEqualTo(Date value) {
            addCriterion("CREATE_DATE =", value, "CREATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateNotEqualTo(Date value) {
            addCriterion("CREATE_DATE <>", value, "CREATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateGreaterThan(Date value) {
            addCriterion("CREATE_DATE >", value, "CREATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE >=", value, "CREATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateLessThan(Date value) {
            addCriterion("CREATE_DATE <", value, "CREATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE <=", value, "CREATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateLike(Date value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateNotLike(Date value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 1);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateLeftLike(Date value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateNotLeftLike(Date value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 0);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateRightLike(Date value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateNotRightLike(Date value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 2);
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateIn(List<Date> values) {
            addCriterion("CREATE_DATE  in ", values, "CREATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateNotIn(List<Date> values) {
            addCriterion("CREATE_DATE not in ", values, "CREATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE between ", value1, value2, "CREATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

        public DmHostConnInfoCriteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE not between ", value1, value2, "CREATE_DATE");
            return (DmHostConnInfoCriteria) this;
        }

    }

    public static class DmHostConnInfoCriteria extends GeneratedCriteria {

        protected DmHostConnInfoCriteria() {
            super();
        }
    }

    public static class DmHostConnInfoCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected DmHostConnInfoCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected DmHostConnInfoCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected DmHostConnInfoCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected DmHostConnInfoCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected DmHostConnInfoCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected DmHostConnInfoCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}